www.gusucode.com > PHP开源客户管理系统 v1.0PHP源码程序 > PHP开源客户管理系统 v1.0/khglxt_A5/khglxt_A5/app/models/kehu_m.php
<?php class Kehu_m extends Ci_Model { function __construct () { parent::__construct(); } public function check_select($pid) { mysql_query("SET NAMES GBK"); $this->db->select('*'); $this->db->order_by('top','asc'); $query = $this->db->get_where('tb_fenlei',array('fsid'=>$pid,'show'=>'1')); return $query->result_array(); } public function check_kehunumber($pid) { mysql_query("SET NAMES GBK"); $this->db->select('*'); $this->db->order_by('id','asc'); $query = $this->db->get_where('tb_kehu',array('tb_khlx'=>$pid)); return $query->num_rows(); } public function get_kehu_list ($page,$limit) { $this->db->select('*'); $this->db->order_by('id','desc'); $this->db->limit($limit,$page); $query = $this->db->get('tb_kehu'); if($query->num_rows() > 0){ return $query->result_array(); } } public function get_yewu_list ($page,$limit) { $this->db->select('*'); $this->db->order_by('id','desc'); $this->db->limit($limit,$page); $query = $this->db->get('tb_yewu'); if($query->num_rows() > 0){ return $query->result_array(); } } public function get_skehu_list ($lx='tb_khmc',$title='',$khlx='0') { $this->db->select('*'); //$this->db->where(); if ($khlx!='0'){ $this->db->where(array('tb_khlx'=>$khlx)); } $this->db->like($lx, $title, 'both'); $this->db->order_by('id','desc'); $query = $this->db->get('tb_kehu'); if($query->num_rows() > 0){ return $query->result_array(); } } public function get_syewu_list ($khid='',$cpmc='',$dqrq1='',$dqrq2='') { $this->db->select('*'); if ($khid!=''){ $this->db->where(array('khid'=>$khid)); } if ($cpmc!=''){ $this->db->like('cpmc', $cpmc, 'both'); } if ($dqrq1!=''){ $this->db->where('dqrq >=',$dqrq1); } if ($dqrq2!=''){ $this->db->where('dqrq <=',$dqrq2); } $this->db->order_by('id','desc'); $query = $this->db->get('tb_yewu'); if($query->num_rows() > 0){ return $query->result_array(); } } public function add_kehu($data) { mysql_query("SET NAMES GBK"); $this->db->insert('tb_kehu',$data); return ($this->db->affected_rows() > 0) ? TRUE : FALSE; } public function add_yewu($data) { mysql_query("SET NAMES GBK"); $this->db->insert('tb_yewu',$data); return ($this->db->affected_rows() > 0) ? TRUE : FALSE; } public function update_kehu($id, $data){ $this->db->where('id',$id); $this->db->update('tb_kehu', $data); return ($this->db->affected_rows() > 0) ? TRUE : FALSE; } public function update_yewu($id, $data){ $this->db->where('id',$id); $this->db->update('tb_yewu', $data); return ($this->db->affected_rows() > 0) ? TRUE : FALSE; } public function get_kehu_by_id($id) { $query = $this->db->get_where('tb_kehu',array('id'=>$id)); if($query->num_rows>0){ return $query->row_array(); } } public function get_yewu_by_id($id) { $query = $this->db->get_where('tb_yewu',array('id'=>$id)); if($query->num_rows>0){ return $query->row_array(); } } public function select_khname($id) { $query = $this->db->get_where('tb_kehu',array('id'=>$id)); //if($query->num_rows>0){ return $query->result_array(); //} } function del_kehu($id) { $this->db->where('id', $id)->delete('tb_kehu'); return ($this->db->affected_rows() > 0) ? TRUE : FALSE; } function del_yewu($id) { $this->db->where('id', $id)->delete('tb_yewu'); return ($this->db->affected_rows() > 0) ? TRUE : FALSE; } }